/****************************************************************************
 *
 * Copyright (C) 2003-2008 Los Alamos National Security, LLC
 *                         Packet Analytics Corporation
 *
 * This program is free software; you can redistribute it and/or modify
 * it under the terms of the GNU General Public License Version 2 as
 * published by the Free Software Foundation.  You may not use, modify or
 * distribute this program under any other version of the GNU General
 * Public License.
 *
 * This program is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU General Public License for more details.
 *
 * You should have received a copy of the GNU General Public License
 * along with this program; if not, write to the Free Software
 * Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.
 *
 ****************************************************************************/
package nfse.misc;

import java.io.*;

public class MySQLDumpToRecords {

    public static void main(String[] args) {
        try {
            BufferedReader in = new BufferedReader(new InputStreamReader(System.in));
            String line = in.readLine();
            while (line != null) {
                int lastStartIdx = 0;
                if (line.startsWith("INSERT INTO `")) {
                    int endIdx = -1;
                    do {
                        int startIdx = line.indexOf("','", lastStartIdx);
                        if (startIdx != -1) {
                            startIdx += 3;
                            endIdx = line.indexOf("')", startIdx + 1);
                            if (endIdx != -1) {
                                String record = line.substring(startIdx, endIdx);

                                System.out.println(record);
                            }
                            lastStartIdx = endIdx + 5;
                        } else {
                            endIdx = -1;
                        }
                    } while (endIdx != -1 && line.charAt(endIdx + 1) == ',');
                }
                line = in.readLine();
            }
            in.close();
        } catch (Exception E) {
            E.printStackTrace();
        }
    }

}
